SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE dbo.[DnnProduct_GetModulePermissionsByPortal]
	
	@PortalID int

AS
SELECT *
FROM dbo.DnnProduct_vw_ModulePermissions MP
	INNER JOIN dbo.DnnProduct_Modules AS M ON MP.ModuleID = M.ModuleID 
WHERE  M.PortalID = @PortalID

GO
